Overview

Brought to you by YData

Dataset statistics

Number of variables	24
Number of observations	7719
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	8.6 MiB
Average record size in memory	1.1 KiB

Variable types

Numeric	6
Text	8
DateTime	2
Categorical	8

Alerts

`Category` is highly overall correlated with `Sub-Category`	High correlation
`Market` is highly overall correlated with `Region`	High correlation
`Region` is highly overall correlated with `Market`	High correlation
`Row ID` is highly overall correlated with `Shipping Cost`	High correlation
`Sales` is highly overall correlated with `Shipping Cost`	High correlation
`Shipping Cost` is highly overall correlated with `Row ID` and 1 other fields	High correlation
`Sub-Category` is highly overall correlated with `Category`	High correlation
`Row ID` has unique values	Unique
`Discount` has 4504 (58.3%) zeros	Zeros
`Profit` has 101 (1.3%) zeros	Zeros

Reproduction

Analysis started	2025-01-23 12:04:54.756750
Analysis finished	2025-01-23 12:05:01.331035
Duration	6.57 seconds
Software version	ydata-profiling vv4.12.2
Download configuration	config.json

Row ID
Real number (ℝ)

High correlation Unique

Distinct	7719
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5588.1985

Minimum	1
Maximum	9999
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	60.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1384.8
Q1	3424.5
median	5651
Q3	7826.5
95-th percentile	9565.1
Maximum	9999
Range	9998
Interquartile range (IQR)	4402

Descriptive statistics

Standard deviation	2610.2139
Coefficient of variation (CV)	0.46709399
Kurtosis	-1.0934312
Mean	5588.1985
Median Absolute Deviation (MAD)	2202
Skewness	-0.10128571
Sum	43135304
Variance	6813216.6
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	< 0.1%
7155	1	< 0.1%
7116	1	< 0.1%
7114	1	< 0.1%
7111	1	< 0.1%
7110	1	< 0.1%
7108	1	< 0.1%
7107	1	< 0.1%
7106	1	< 0.1%
7105	1	< 0.1%
Other values (7709)	7709	99.9%

Value	Count	Frequency (%)
1	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%
11	1	< 0.1%
17	1	< 0.1%
22	1	< 0.1%
29	1	< 0.1%
33	1	< 0.1%
35	1	< 0.1%
37	1	< 0.1%

Value	Count	Frequency (%)
9999	1	< 0.1%
9998	1	< 0.1%
9997	1	< 0.1%
9996	1	< 0.1%
9995	1	< 0.1%
9994	1	< 0.1%
9992	1	< 0.1%
9991	1	< 0.1%
9990	1	< 0.1%
9989	1	< 0.1%

Order ID
Text

Distinct	5985
Distinct (%)	77.5%
Missing	0
Missing (%)	0.0%
Memory size	604.2 KiB

Length

Max length	24
Median length	23
Mean length	23.137842
Min length	20

Characters and Unicode

Total characters	178601
Distinct characters	40
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4777 ?
Unique (%)	61.9%

Sample

1st row	CA-2014-AB10015140-41954
2nd row	CA-2014-AB10015140-41954
3rd row	CA-2012-AB10015140-40974
4th row	CA-2012-AB10015140-40974
5th row	CA-2012-AB10015140-40958

Value	Count	Frequency (%)
ca-2015-ac10615140-42250	11	0.1%
ca-2014-ag10270140-41896	9	0.1%
ca-2013-bt11680140-41464	9	0.1%
ca-2012-aj10795140-41271	7	0.1%
ca-2014-ai10855140-41954	7	0.1%
ca-2015-am10705140-42207	7	0.1%
ca-2013-bs11665140-41595	7	0.1%
ca-2015-as10225140-42265	7	0.1%
ca-2012-bh11710140-41068	7	0.1%
ca-2015-bs11800140-42104	6	0.1%
Other values (5975)	7642	99.0%

Most occurring characters

Value	Count	Frequency (%)
1	28019	15.7%
-	23157	13.0%
0	19382	10.9%
2	19269	10.8%
4	16725	9.4%
5	12063	6.8%
3	7389	4.1%
8	6066	3.4%
9	5634	3.2%
7	5282	3.0%
Other values (30)	35615	19.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	178601	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	28019	15.7%
-	23157	13.0%
0	19382	10.9%
2	19269	10.8%
4	16725	9.4%
5	12063	6.8%
3	7389	4.1%
8	6066	3.4%
9	5634	3.2%
7	5282	3.0%
Other values (30)	35615	19.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	178601	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	28019	15.7%
-	23157	13.0%
0	19382	10.9%
2	19269	10.8%
4	16725	9.4%
5	12063	6.8%
3	7389	4.1%
8	6066	3.4%
9	5634	3.2%
7	5282	3.0%
Other values (30)	35615	19.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	178601	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	28019	15.7%
-	23157	13.0%
0	19382	10.9%
2	19269	10.8%
4	16725	9.4%
5	12063	6.8%
3	7389	4.1%
8	6066	3.4%
9	5634	3.2%
7	5282	3.0%
Other values (30)	35615	19.9%

Order Date
Date

Distinct	1290
Distinct (%)	16.7%
Missing	0
Missing (%)	0.0%
Memory size	60.4 KiB

Minimum	2012-01-01 00:00:00
Maximum	2015-12-31 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

Ship Date
Date

Distinct	1384
Distinct (%)	17.9%
Missing	0
Missing (%)	0.0%
Memory size	60.4 KiB

Minimum	2012-01-03 00:00:00
Maximum	2016-01-06 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

Ship Mode
Categorical

Distinct	4
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	524.6 KiB

Standard Class	4004
Second Class	1690
First Class	1505
Same Day	520

Length

Max length	14
Median length	14
Mean length	12.573002
Min length	8

Characters and Unicode

Total characters	97051
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	First Class
2nd row	First Class
3rd row	First Class
4th row	First Class
5th row	Standard Class

Common Values

Value	Count	Frequency (%)
Standard Class	4004	51.9%
Second Class	1690	21.9%
First Class	1505	19.5%
Same Day	520	6.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
class	7199	46.6%
standard	4004	25.9%
second	1690	10.9%
first	1505	9.7%
same	520	3.4%
day	520	3.4%

Most occurring characters

Value	Count	Frequency (%)
a	16247	16.7%
s	15903	16.4%
d	9698	10.0%
	7719	8.0%
l	7199	7.4%
C	7199	7.4%
S	6214	6.4%
n	5694	5.9%
r	5509	5.7%
t	5509	5.7%
Other values (8)	10160	10.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	97051	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	16247	16.7%
s	15903	16.4%
d	9698	10.0%
	7719	8.0%
l	7199	7.4%
C	7199	7.4%
S	6214	6.4%
n	5694	5.9%
r	5509	5.7%
t	5509	5.7%
Other values (8)	10160	10.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	97051	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	16247	16.7%
s	15903	16.4%
d	9698	10.0%
	7719	8.0%
l	7199	7.4%
C	7199	7.4%
S	6214	6.4%
n	5694	5.9%
r	5509	5.7%
t	5509	5.7%
Other values (8)	10160	10.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	97051	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	16247	16.7%
s	15903	16.4%
d	9698	10.0%
	7719	8.0%
l	7199	7.4%
C	7199	7.4%
S	6214	6.4%
n	5694	5.9%
r	5509	5.7%
t	5509	5.7%
Other values (8)	10160	10.5%

Customer ID
Text

Distinct	5009
Distinct (%)	64.9%
Missing	0
Missing (%)	0.0%
Memory size	507.7 KiB

Length

Max length	12
Median length	10
Mean length	10.336183
Min length	7

Characters and Unicode

Total characters	79785
Distinct characters	40
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3520 ?
Unique (%)	45.6%

Sample

1st row	AB-100151402
2nd row	AB-100151402
3rd row	AB-100151404
4th row	AB-100151404
5th row	AB-100151402

Value	Count	Frequency (%)
ap-109151404	22	0.3%
bm-116501402	16	0.2%
ai-108551404	15	0.2%
ac-106151406	13	0.2%
bt-116801406	13	0.2%
bd-113201404	13	0.2%
aj-107951404	12	0.2%
bc-111251404	11	0.1%
bp-110951404	11	0.1%
as-100901406	10	0.1%
Other values (4999)	7583	98.2%

Most occurring characters

Value	Count	Frequency (%)
1	12937	16.2%
0	9166	11.5%
-	7719	9.7%
5	7241	9.1%
4	5414	6.8%
2	4884	6.1%
8	4089	5.1%
7	3331	4.2%
3	3250	4.1%
9	3165	4.0%
Other values (30)	18589	23.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	79785	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	12937	16.2%
0	9166	11.5%
-	7719	9.7%
5	7241	9.1%
4	5414	6.8%
2	4884	6.1%
8	4089	5.1%
7	3331	4.2%
3	3250	4.1%
9	3165	4.0%
Other values (30)	18589	23.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	79785	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	12937	16.2%
0	9166	11.5%
-	7719	9.7%
5	7241	9.1%
4	5414	6.8%
2	4884	6.1%
8	4089	5.1%
7	3331	4.2%
3	3250	4.1%
9	3165	4.0%
Other values (30)	18589	23.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	79785	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	12937	16.2%
0	9166	11.5%
-	7719	9.7%
5	7241	9.1%
4	5414	6.8%
2	4884	6.1%
8	4089	5.1%
7	3331	4.2%
3	3250	4.1%
9	3165	4.0%
Other values (30)	18589	23.3%

Customer Name
Text

Distinct	792
Distinct (%)	10.3%
Missing	0
Missing (%)	0.0%
Memory size	531.0 KiB

Length

Max length	22
Median length	18
Mean length	12.953621
Min length	7

Characters and Unicode

Total characters	99989
Distinct characters	57
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	8 ?
Unique (%)	0.1%

Sample

1st row	Aaron Bergman
2nd row	Aaron Bergman
3rd row	Aaron Bergman
4th row	Aaron Bergman
5th row	Aaron Bergman

Value	Count	Frequency (%)
brian	126	0.8%
alan	116	0.7%
barry	116	0.7%
anthony	102	0.7%
bill	98	0.6%
anna	89	0.6%
adam	82	0.5%
arthur	79	0.5%
ben	77	0.5%
paul	76	0.5%
Other values (899)	14519	93.8%

Most occurring characters

Value	Count	Frequency (%)
a	9119	9.1%
e	8990	9.0%
n	8209	8.2%
	7761	7.8%
r	7468	7.5%
i	5671	5.7%
l	5296	5.3%
o	4687	4.7%
t	4119	4.1%
s	3496	3.5%
Other values (47)	35173	35.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	99989	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	9119	9.1%
e	8990	9.0%
n	8209	8.2%
	7761	7.8%
r	7468	7.5%
i	5671	5.7%
l	5296	5.3%
o	4687	4.7%
t	4119	4.1%
s	3496	3.5%
Other values (47)	35173	35.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	99989	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	9119	9.1%
e	8990	9.0%
n	8209	8.2%
	7761	7.8%
r	7468	7.5%
i	5671	5.7%
l	5296	5.3%
o	4687	4.7%
t	4119	4.1%
s	3496	3.5%
Other values (47)	35173	35.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	99989	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	9119	9.1%
e	8990	9.0%
n	8209	8.2%
	7761	7.8%
r	7468	7.5%
i	5671	5.7%
l	5296	5.3%
o	4687	4.7%
t	4119	4.1%
s	3496	3.5%
Other values (47)	35173	35.2%

Segment
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	496.4 KiB

Consumer	4005
Corporate	2358
Home Office	1356

Length

Max length	11
Median length	8
Mean length	8.8324913
Min length	8

Characters and Unicode

Total characters	68178
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Consumer
2nd row	Consumer
3rd row	Consumer
4th row	Consumer
5th row	Consumer

Common Values

Value	Count	Frequency (%)
Consumer	4005	51.9%
Corporate	2358	30.5%
Home Office	1356	17.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
consumer	4005	44.1%
corporate	2358	26.0%
home	1356	14.9%
office	1356	14.9%

Most occurring characters

Value	Count	Frequency (%)
o	10077	14.8%
e	9075	13.3%
r	8721	12.8%
C	6363	9.3%
m	5361	7.9%
n	4005	5.9%
s	4005	5.9%
u	4005	5.9%
f	2712	4.0%
t	2358	3.5%
Other values (7)	11496	16.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	68178	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	10077	14.8%
e	9075	13.3%
r	8721	12.8%
C	6363	9.3%
m	5361	7.9%
n	4005	5.9%
s	4005	5.9%
u	4005	5.9%
f	2712	4.0%
t	2358	3.5%
Other values (7)	11496	16.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	68178	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	10077	14.8%
e	9075	13.3%
r	8721	12.8%
C	6363	9.3%
m	5361	7.9%
n	4005	5.9%
s	4005	5.9%
u	4005	5.9%
f	2712	4.0%
t	2358	3.5%
Other values (7)	11496	16.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	68178	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	10077	14.8%
e	9075	13.3%
r	8721	12.8%
C	6363	9.3%
m	5361	7.9%
n	4005	5.9%
s	4005	5.9%
u	4005	5.9%
f	2712	4.0%
t	2358	3.5%
Other values (7)	11496	16.9%

City
Text

Distinct	1992
Distinct (%)	25.8%
Missing	0
Missing (%)	0.0%
Memory size	506.1 KiB

Length

Max length	26
Median length	22
Mean length	8.4271279
Min length	3

Characters and Unicode

Total characters	65049
Distinct characters	71
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	785 ?
Unique (%)	10.2%

Sample

1st row	Oklahoma City
2nd row	Oklahoma City
3rd row	Seattle
4th row	Seattle
5th row	Arlington

Value	Count	Frequency (%)
city	300	3.1%
san	261	2.7%
los	183	1.9%
york	174	1.8%
new	173	1.8%
angeles	170	1.8%
francisco	96	1.0%
philadelphia	78	0.8%
de	76	0.8%
manila	73	0.8%
Other values (2111)	8048	83.6%

Most occurring characters

Value	Count	Frequency (%)
a	7911	12.2%
n	5116	7.9%
e	5085	7.8%
o	4574	7.0%
i	4019	6.2%
r	3599	5.5%
l	3218	4.9%
s	2390	3.7%
t	2387	3.7%
u	2283	3.5%
Other values (61)	24467	37.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	65049	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	7911	12.2%
n	5116	7.9%
e	5085	7.8%
o	4574	7.0%
i	4019	6.2%
r	3599	5.5%
l	3218	4.9%
s	2390	3.7%
t	2387	3.7%
u	2283	3.5%
Other values (61)	24467	37.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	65049	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	7911	12.2%
n	5116	7.9%
e	5085	7.8%
o	4574	7.0%
i	4019	6.2%
r	3599	5.5%
l	3218	4.9%
s	2390	3.7%
t	2387	3.7%
u	2283	3.5%
Other values (61)	24467	37.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	65049	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	7911	12.2%
n	5116	7.9%
e	5085	7.8%
o	4574	7.0%
i	4019	6.2%
r	3599	5.5%
l	3218	4.9%
s	2390	3.7%
t	2387	3.7%
u	2283	3.5%
Other values (61)	24467	37.6%

State
Text

Distinct	709
Distinct (%)	9.2%
Missing	0
Missing (%)	0.0%
Memory size	534.3 KiB

Length

Max length	36
Median length	33
Mean length	10.38321
Min length	3

Characters and Unicode

Total characters	80148
Distinct characters	76
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	171 ?
Unique (%)	2.2%

Sample

1st row	Oklahoma
2nd row	Oklahoma
3rd row	Washington
4th row	Washington
5th row	Texas

Value	Count	Frequency (%)
california	387	3.7%
new	380	3.6%
england	299	2.9%
south	208	2.0%
ile-de-france	205	2.0%
york	198	1.9%
north	174	1.7%
wales	155	1.5%
queensland	144	1.4%
rhine-westphalia	136	1.3%
Other values (793)	8142	78.1%

Most occurring characters

Value	Count	Frequency (%)
a	11393	14.2%
n	6468	8.1%
e	5543	6.9%
i	5479	6.8%
r	4595	5.7%
o	4384	5.5%
l	3871	4.8%
t	3350	4.2%
s	3015	3.8%
	2709	3.4%
Other values (66)	29341	36.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	80148	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	11393	14.2%
n	6468	8.1%
e	5543	6.9%
i	5479	6.8%
r	4595	5.7%
o	4384	5.5%
l	3871	4.8%
t	3350	4.2%
s	3015	3.8%
	2709	3.4%
Other values (66)	29341	36.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	80148	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	11393	14.2%
n	6468	8.1%
e	5543	6.9%
i	5479	6.8%
r	4595	5.7%
o	4384	5.5%
l	3871	4.8%
t	3350	4.2%
s	3015	3.8%
	2709	3.4%
Other values (66)	29341	36.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	80148	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	11393	14.2%
n	6468	8.1%
e	5543	6.9%
i	5479	6.8%
r	4595	5.7%
o	4384	5.5%
l	3871	4.8%
t	3350	4.2%
s	3015	3.8%
	2709	3.4%
Other values (66)	29341	36.6%

Country
Text

Distinct	132
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Memory size	496.1 KiB

Length

Max length	32
Median length	22
Mean length	8.7988081
Min length	4

Characters and Unicode

Total characters	67918
Distinct characters	54
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	21 ?
Unique (%)	0.3%

Sample

1st row	United States
2nd row	United States
3rd row	United States
4th row	United States
5th row	United States

Value	Count	Frequency (%)
united	1857	18.0%
states	1531	14.9%
france	546	5.3%
australia	530	5.1%
mexico	427	4.1%
china	424	4.1%
germany	412	4.0%
kingdom	326	3.2%
india	320	3.1%
brazil	234	2.3%
Other values (140)	3690	35.8%

Most occurring characters

Value	Count	Frequency (%)
a	8487	12.5%
i	6264	9.2%
e	6175	9.1%
t	6164	9.1%
n	5834	8.6%
d	3343	4.9%
r	2808	4.1%
s	2785	4.1%
	2578	3.8%
o	2101	3.1%
Other values (44)	21379	31.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	67918	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	8487	12.5%
i	6264	9.2%
e	6175	9.1%
t	6164	9.1%
n	5834	8.6%
d	3343	4.9%
r	2808	4.1%
s	2785	4.1%
	2578	3.8%
o	2101	3.1%
Other values (44)	21379	31.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	67918	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	8487	12.5%
i	6264	9.2%
e	6175	9.1%
t	6164	9.1%
n	5834	8.6%
d	3343	4.9%
r	2808	4.1%
s	2785	4.1%
	2578	3.8%
o	2101	3.1%
Other values (44)	21379	31.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	67918	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	8487	12.5%
i	6264	9.2%
e	6175	9.1%
t	6164	9.1%
n	5834	8.6%
d	3343	4.9%
r	2808	4.1%
s	2785	4.1%
	2578	3.8%
o	2101	3.1%
Other values (44)	21379	31.5%

Region
Categorical

High correlation

Distinct	23
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	524.3 KiB

Western Europe	1079
Central America	816
Oceania	632
Western US	542
Eastern Asia	499
Other values (18)	4151

Length

Max length	17
Median length	14
Mean length	12.536468
Min length	6

Characters and Unicode

Total characters	96769
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Central US
2nd row	Central US
3rd row	Western US
4th row	Western US
5th row	Central US

Common Values

Value	Count	Frequency (%)
Western Europe	1079	14.0%
Central America	816	10.6%
Oceania	632	8.2%
Western US	542	7.0%
Eastern Asia	499	6.5%
Southeastern Asia	485	6.3%
Southern Asia	459	5.9%
Eastern US	457	5.9%
South America	397	5.1%
Southern Europe	356	4.6%
Other values (13)	1997	25.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
europe	2001	13.8%
western	1835	12.6%
asia	1584	10.9%
us	1531	10.5%
eastern	1250	8.6%
central	1226	8.4%
america	1213	8.4%
southern	1104	7.6%
oceania	632	4.4%
southeastern	485	3.3%
Other values (6)	1660	11.4%

Most occurring characters

Value	Count	Frequency (%)
e	12653	13.1%
r	10679	11.0%
a	8116	8.4%
t	7287	7.5%
n	7170	7.4%
	6802	7.0%
s	5154	5.3%
o	4492	4.6%
i	4136	4.3%
u	3987	4.1%
Other values (16)	26293	27.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	96769	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	12653	13.1%
r	10679	11.0%
a	8116	8.4%
t	7287	7.5%
n	7170	7.4%
	6802	7.0%
s	5154	5.3%
o	4492	4.6%
i	4136	4.3%
u	3987	4.1%
Other values (16)	26293	27.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	96769	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	12653	13.1%
r	10679	11.0%
a	8116	8.4%
t	7287	7.5%
n	7170	7.4%
	6802	7.0%
s	5154	5.3%
o	4492	4.6%
i	4136	4.3%
u	3987	4.1%
Other values (16)	26293	27.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	96769	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	12653	13.1%
r	10679	11.0%
a	8116	8.4%
t	7287	7.5%
n	7170	7.4%
	6802	7.0%
s	5154	5.3%
o	4492	4.6%
i	4136	4.3%
u	3987	4.1%
Other values (16)	26293	27.2%

Market
Categorical

High correlation

Distinct	5
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	483.5 KiB

Asia Pacific	2216
Europe	2001
USCA	1582
LATAM	1447
Africa	473

Length

Max length	12
Median length	6
Mean length	7.1251457
Min length	4

Characters and Unicode

Total characters	54999
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	USCA
2nd row	USCA
3rd row	USCA
4th row	USCA
5th row	USCA

Common Values

Value	Count	Frequency (%)
Asia Pacific	2216	28.7%
Europe	2001	25.9%
USCA	1582	20.5%
LATAM	1447	18.7%
Africa	473	6.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
asia	2216	22.3%
pacific	2216	22.3%
europe	2001	20.1%
usca	1582	15.9%
latam	1447	14.6%
africa	473	4.8%

Most occurring characters

Value	Count	Frequency (%)
A	7165	13.0%
i	7121	12.9%
c	4905	8.9%
a	4905	8.9%
f	2689	4.9%
r	2474	4.5%
P	2216	4.0%
	2216	4.0%
s	2216	4.0%
E	2001	3.6%
Other values (10)	17091	31.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	54999	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	7165	13.0%
i	7121	12.9%
c	4905	8.9%
a	4905	8.9%
f	2689	4.9%
r	2474	4.5%
P	2216	4.0%
	2216	4.0%
s	2216	4.0%
E	2001	3.6%
Other values (10)	17091	31.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	54999	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	7165	13.0%
i	7121	12.9%
c	4905	8.9%
a	4905	8.9%
f	2689	4.9%
r	2474	4.5%
P	2216	4.0%
	2216	4.0%
s	2216	4.0%
E	2001	3.6%
Other values (10)	17091	31.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	54999	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	7165	13.0%
i	7121	12.9%
c	4905	8.9%
a	4905	8.9%
f	2689	4.9%
r	2474	4.5%
P	2216	4.0%
	2216	4.0%
s	2216	4.0%
E	2001	3.6%
Other values (10)	17091	31.1%

Product ID
Text

Distinct	2245
Distinct (%)	29.1%
Missing	0
Missing (%)	0.0%
Memory size	512.7 KiB

Length

Max length	11
Median length	11
Mean length	11
Min length	11

Characters and Unicode

Total characters	84909
Distinct characters	27
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	934 ?
Unique (%)	12.1%

Sample

1st row	TEC-PH-5816
2nd row	FUR-BO-5957
3rd row	FUR-CH-4421
4th row	OFF-AR-5309
5th row	OFF-ST-3078

Value	Count	Frequency (%)
off-fa-6129	44	0.6%
off-st-4057	41	0.5%
fur-ch-5441	28	0.4%
off-st-6047	25	0.3%
off-st-6033	25	0.3%
off-st-5693	24	0.3%
off-st-4268	23	0.3%
off-st-4267	23	0.3%
off-st-6248	23	0.3%
fur-ch-4654	23	0.3%
Other values (2235)	7440	96.4%

Most occurring characters

Value	Count	Frequency (%)
-	15438	18.2%
F	7859	9.3%
C	5193	6.1%
5	5099	6.0%
4	4468	5.3%
O	4408	5.2%
3	3972	4.7%
T	3879	4.6%
6	3313	3.9%
U	2860	3.4%
Other values (17)	28420	33.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	84909	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
-	15438	18.2%
F	7859	9.3%
C	5193	6.1%
5	5099	6.0%
4	4468	5.3%
O	4408	5.2%
3	3972	4.7%
T	3879	4.6%
6	3313	3.9%
U	2860	3.4%
Other values (17)	28420	33.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	84909	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
-	15438	18.2%
F	7859	9.3%
C	5193	6.1%
5	5099	6.0%
4	4468	5.3%
O	4408	5.2%
3	3972	4.7%
T	3879	4.6%
6	3313	3.9%
U	2860	3.4%
Other values (17)	28420	33.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	84909	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
-	15438	18.2%
F	7859	9.3%
C	5193	6.1%
5	5099	6.0%
4	4468	5.3%
O	4408	5.2%
3	3972	4.7%
T	3879	4.6%
6	3313	3.9%
U	2860	3.4%
Other values (17)	28420	33.5%

E-Commerce Site
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	485.6 KiB

Snapdeal	2887
Flipkart	2531
Amazon	2301

Length

Max length	8
Median length	8
Mean length	7.4038088
Min length	6

Characters and Unicode

Total characters	57150
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Snapdeal
2nd row	Snapdeal
3rd row	Snapdeal
4th row	Flipkart
5th row	Amazon

Common Values

Value	Count	Frequency (%)
Snapdeal	2887	37.4%
Flipkart	2531	32.8%
Amazon	2301	29.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
snapdeal	2887	37.4%
flipkart	2531	32.8%
amazon	2301	29.8%

Most occurring characters

Value	Count	Frequency (%)
a	10606	18.6%
p	5418	9.5%
l	5418	9.5%
n	5188	9.1%
S	2887	5.1%
d	2887	5.1%
e	2887	5.1%
F	2531	4.4%
i	2531	4.4%
k	2531	4.4%
Other values (6)	14266	25.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	57150	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	10606	18.6%
p	5418	9.5%
l	5418	9.5%
n	5188	9.1%
S	2887	5.1%
d	2887	5.1%
e	2887	5.1%
F	2531	4.4%
i	2531	4.4%
k	2531	4.4%
Other values (6)	14266	25.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	57150	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	10606	18.6%
p	5418	9.5%
l	5418	9.5%
n	5188	9.1%
S	2887	5.1%
d	2887	5.1%
e	2887	5.1%
F	2531	4.4%
i	2531	4.4%
k	2531	4.4%
Other values (6)	14266	25.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	57150	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	10606	18.6%
p	5418	9.5%
l	5418	9.5%
n	5188	9.1%
S	2887	5.1%
d	2887	5.1%
e	2887	5.1%
F	2531	4.4%
i	2531	4.4%
k	2531	4.4%
Other values (6)	14266	25.0%

Category
Categorical

High correlation

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	515.0 KiB

Technology	2780
Office Supplies	2505
Furniture	2434

Length

Max length	15
Median length	10
Mean length	11.307294
Min length	9

Characters and Unicode

Total characters	87281
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Technology
2nd row	Furniture
3rd row	Furniture
4th row	Office Supplies
5th row	Office Supplies

Common Values

Value	Count	Frequency (%)
Technology	2780	36.0%
Office Supplies	2505	32.5%
Furniture	2434	31.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
technology	2780	27.2%
office	2505	24.5%
supplies	2505	24.5%
furniture	2434	23.8%

Most occurring characters

Value	Count	Frequency (%)
e	10224	11.7%
i	7444	8.5%
u	7373	8.4%
o	5560	6.4%
c	5285	6.1%
l	5285	6.1%
n	5214	6.0%
f	5010	5.7%
p	5010	5.7%
r	4868	5.6%
Other values (10)	26008	29.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	87281	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	10224	11.7%
i	7444	8.5%
u	7373	8.4%
o	5560	6.4%
c	5285	6.1%
l	5285	6.1%
n	5214	6.0%
f	5010	5.7%
p	5010	5.7%
r	4868	5.6%
Other values (10)	26008	29.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	87281	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	10224	11.7%
i	7444	8.5%
u	7373	8.4%
o	5560	6.4%
c	5285	6.1%
l	5285	6.1%
n	5214	6.0%
f	5010	5.7%
p	5010	5.7%
r	4868	5.6%
Other values (10)	26008	29.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	87281	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	10224	11.7%
i	7444	8.5%
u	7373	8.4%
o	5560	6.4%
c	5285	6.1%
l	5285	6.1%
n	5214	6.0%
f	5010	5.7%
p	5010	5.7%
r	4868	5.6%
Other values (10)	26008	29.8%

Sub-Category
Categorical

High correlation

Distinct	17
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	486.2 KiB

Copiers	953
Bookcases	950
Chairs	927
Storage	876
Phones	862
Other values (12)	3151

Length

Max length	11
Median length	10
Mean length	7.486462
Min length	3

Characters and Unicode

Total characters	57788
Distinct characters	28
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Phones
2nd row	Bookcases
3rd row	Chairs
4th row	Art
5th row	Storage

Common Values

Value	Count	Frequency (%)
Copiers	953	12.3%
Bookcases	950	12.3%
Chairs	927	12.0%
Storage	876	11.3%
Phones	862	11.2%
Accessories	533	6.9%
Appliances	475	6.2%
Machines	432	5.6%
Furnishings	334	4.3%
Art	302	3.9%
Other values (7)	1075	13.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
copiers	953	12.3%
bookcases	950	12.3%
chairs	927	12.0%
storage	876	11.3%
phones	862	11.2%
accessories	533	6.9%
appliances	475	6.2%
machines	432	5.6%
furnishings	334	4.3%
art	302	3.9%
Other values (7)	1075	13.9%

Most occurring characters

Value	Count	Frequency (%)
s	8677	15.0%
e	6846	11.8%
o	5200	9.0%
r	4543	7.9%
a	4325	7.5%
i	4322	7.5%
c	2923	5.1%
n	2836	4.9%
h	2555	4.4%
p	2458	4.3%
Other values (18)	13103	22.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	57788	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
s	8677	15.0%
e	6846	11.8%
o	5200	9.0%
r	4543	7.9%
a	4325	7.5%
i	4322	7.5%
c	2923	5.1%
n	2836	4.9%
h	2555	4.4%
p	2458	4.3%
Other values (18)	13103	22.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	57788	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
s	8677	15.0%
e	6846	11.8%
o	5200	9.0%
r	4543	7.9%
a	4325	7.5%
i	4322	7.5%
c	2923	5.1%
n	2836	4.9%
h	2555	4.4%
p	2458	4.3%
Other values (18)	13103	22.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	57788	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
s	8677	15.0%
e	6846	11.8%
o	5200	9.0%
r	4543	7.9%
a	4325	7.5%
i	4322	7.5%
c	2923	5.1%
n	2836	4.9%
h	2555	4.4%
p	2458	4.3%
Other values (18)	13103	22.7%

Product Name
Text

Distinct	2245
Distinct (%)	29.1%
Missing	0
Missing (%)	0.0%
Memory size	661.9 KiB

Length

Max length	109
Median length	88
Mean length	30.371551
Min length	5

Characters and Unicode

Total characters	234438
Distinct characters	82
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	934 ?
Unique (%)	12.1%

Sample

1st row	Samsung Convoy 3
2nd row	Sauder Facets Collection Library, Sky Alder Finish
3rd row	Global Push Button Manager's Chair, Indigo
4th row	Newell 330
5th row	Akro Stacking Bins

Value	Count	Frequency (%)
fax	515	1.5%
with	489	1.4%
machine	442	1.3%
black	437	1.3%
red	387	1.1%
phone	383	1.1%
chair	369	1.1%
safco	353	1.0%
lockers	343	1.0%
set	336	1.0%
Other values (1969)	30324	88.2%

Most occurring characters

Value	Count	Frequency (%)
	26602	11.3%
e	22053	9.4%
a	15132	6.5%
o	14109	6.0%
r	14054	6.0%
i	13408	5.7%
l	11028	4.7%
t	9853	4.2%
n	9115	3.9%
s	7594	3.2%
Other values (72)	91490	39.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	234438	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	26602	11.3%
e	22053	9.4%
a	15132	6.5%
o	14109	6.0%
r	14054	6.0%
i	13408	5.7%
l	11028	4.7%
t	9853	4.2%
n	9115	3.9%
s	7594	3.2%
Other values (72)	91490	39.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	234438	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	26602	11.3%
e	22053	9.4%
a	15132	6.5%
o	14109	6.0%
r	14054	6.0%
i	13408	5.7%
l	11028	4.7%
t	9853	4.2%
n	9115	3.9%
s	7594	3.2%
Other values (72)	91490	39.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	234438	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	26602	11.3%
e	22053	9.4%
a	15132	6.5%
o	14109	6.0%
r	14054	6.0%
i	13408	5.7%
l	11028	4.7%
t	9853	4.2%
n	9115	3.9%
s	7594	3.2%
Other values (72)	91490	39.0%

Sales
Real number (ℝ)

High correlation

Distinct	6169
Distinct (%)	79.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	505.54721

Minimum	1.728
Maximum	1867.136
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	60.4 KiB

Quantile statistics

Minimum	1.728
5-th percentile	17.336
Q1	236.961
median	438.84
Q3	713.20728
95-th percentile	1236.465
Maximum	1867.136
Range	1865.408
Interquartile range (IQR)	476.24628

Descriptive statistics

Standard deviation	372.1854
Coefficient of variation (CV)	0.73620305
Kurtosis	0.793356
Mean	505.54721
Median Absolute Deviation (MAD)	231.72
Skewness	0.95055385
Sum	3902318.9
Variance	138521.97
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15.552	12	0.2%
17.94	7	0.1%
394.98	7	0.1%
14.94	6	0.1%
272.76	6	0.1%
366.84	6	0.1%
10.368	6	0.1%
12.96	6	0.1%
19.44	5	0.1%
333.96	5	0.1%
Other values (6159)	7653	99.1%

Value	Count	Frequency (%)
1.728	1	< 0.1%
1.744	1	< 0.1%
2.22	1	< 0.1%
2.304	1	< 0.1%
2.6	1	< 0.1%
2.632	1	< 0.1%
2.688	1	< 0.1%
2.89	1	< 0.1%
2.944	1	< 0.1%
2.97	1	< 0.1%

Value	Count	Frequency (%)
1867.136	1	< 0.1%
1860	1	< 0.1%
1859.55	1	< 0.1%
1859.13	1	< 0.1%
1855.68	1	< 0.1%
1854.495	1	< 0.1%
1849.32	1	< 0.1%
1847.34	1	< 0.1%
1845.72	1	< 0.1%
1843.17	1	< 0.1%

Quantity
Real number (ℝ)

Distinct	10
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.0296671

Minimum	1
Maximum	10
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	60.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	5
95-th percentile	8
Maximum	10
Range	9
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.1368146
Coefficient of variation (CV)	0.53027075
Kurtosis	-0.2514218
Mean	4.0296671
Median Absolute Deviation (MAD)	2
Skewness	0.70457992
Sum	31105
Variance	4.5659765
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2	1631	21.1%
3	1582	20.5%
4	1172	15.2%
5	956	12.4%
6	629	8.1%
1	566	7.3%
7	544	7.0%
8	337	4.4%
9	235	3.0%
10	67	0.9%

Value	Count	Frequency (%)
1	566	7.3%
2	1631	21.1%
3	1582	20.5%
4	1172	15.2%
5	956	12.4%
6	629	8.1%
7	544	7.0%
8	337	4.4%
9	235	3.0%
10	67	0.9%

Value	Count	Frequency (%)
10	67	0.9%
9	235	3.0%
8	337	4.4%
7	544	7.0%
6	629	8.1%
5	956	12.4%
4	1172	15.2%
3	1582	20.5%
2	1631	21.1%
1	566	7.3%

Discount
Real number (ℝ)

Zeros

Distinct	16
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.072549035

Minimum	0
Maximum	0.402
Zeros	4504
Zeros (%)	58.3%
Negative	0
Negative (%)	0.0%
Memory size	60.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.1
95-th percentile	0.35
Maximum	0.402
Range	0.402
Interquartile range (IQR)	0.1

Descriptive statistics

Standard deviation	0.10902344
Coefficient of variation (CV)	1.5027552
Kurtosis	1.4627052
Mean	0.072549035
Median Absolute Deviation (MAD)	0
Skewness	1.4896662
Sum	560.006
Variance	0.01188611
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
0	4504	58.3%
0.1	1033	13.4%
0.2	943	12.2%
0.4	287	3.7%
0.002	232	3.0%
0.15	188	2.4%
0.17	130	1.7%
0.07	79	1.0%
0.3	71	0.9%
0.27	69	0.9%
Other values (6)	183	2.4%

Value	Count	Frequency (%)
0	4504	58.3%
0.002	232	3.0%
0.07	79	1.0%
0.1	1033	13.4%
0.15	188	2.4%
0.17	130	1.7%
0.2	943	12.2%
0.202	15	0.2%
0.25	65	0.8%
0.27	69	0.9%

Value	Count	Frequency (%)
0.402	26	0.3%
0.4	287	3.7%
0.37	23	0.3%
0.35	52	0.7%
0.32	2	< 0.1%
0.3	71	0.9%
0.27	69	0.9%
0.25	65	0.8%
0.202	15	0.2%
0.2	943	12.2%

Profit
Real number (ℝ)

Zeros

Distinct	6138
Distinct (%)	79.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	83.874722

Minimum	-254.34
Maximum	437.28
Zeros	101
Zeros (%)	1.3%
Negative	1022
Negative (%)	13.2%
Memory size	60.4 KiB

Quantile statistics

Minimum	-254.34
5-th percentile	-69.52098
Q1	9.177
median	58.23576
Q3	144.42
95-th percentile	312.03958
Maximum	437.28
Range	691.62
Interquartile range (IQR)	135.243

Descriptive statistics

Standard deviation	114.62825
Coefficient of variation (CV)	1.3666602
Kurtosis	0.70938687
Mean	83.874722
Median Absolute Deviation (MAD)	54.95976
Skewness	0.61393802
Sum	647428.98
Variance	13139.635
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	101	1.3%
5.4432	11	0.1%
178.11	7	0.1%
17.58	6	0.1%
5.04	6	0.1%
45.36	6	0.1%
39.54	6	0.1%
93.6	6	0.1%
3.6288	6	0.1%
43.2	6	0.1%
Other values (6128)	7558	97.9%

Value	Count	Frequency (%)
-254.34	1	< 0.1%
-252.9585	1	< 0.1%
-251.74512	1	< 0.1%
-250.82	1	< 0.1%
-248.052	2	< 0.1%
-244.944	1	< 0.1%
-241.296	1	< 0.1%
-241.2	1	< 0.1%
-238.5525	1	< 0.1%
-237.576	2	< 0.1%

Value	Count	Frequency (%)
437.28	1	< 0.1%
436.94	1	< 0.1%
436.77	3	< 0.1%
435.888	1	< 0.1%
435.51	1	< 0.1%
434.4	2	< 0.1%
433.92	1	< 0.1%
433.44	1	< 0.1%
433.41	1	< 0.1%
433.26	1	< 0.1%

Shipping Cost
Real number (ℝ)

High correlation

Distinct	5807
Distinct (%)	75.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	58.977191

Minimum	1.04
Maximum	195.59
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	60.4 KiB

Quantile statistics

Minimum	1.04
5-th percentile	1.8
Q1	36.05
median	51.008
Q3	78.1395
95-th percentile	142.216
Maximum	195.59
Range	194.55
Interquartile range (IQR)	42.0895

Descriptive statistics

Standard deviation	40.540622
Coefficient of variation (CV)	0.68739493
Kurtosis	0.87469424
Mean	58.977191
Median Absolute Deviation (MAD)	17.835
Skewness	0.93630894
Sum	455244.94
Variance	1643.542
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.33	11	0.1%
1.26	10	0.1%
1.27	10	0.1%
1.2	9	0.1%
1.71	9	0.1%
1.49	9	0.1%
1.31	9	0.1%
1.23	9	0.1%
1.41	9	0.1%
1.18	8	0.1%
Other values (5797)	7626	98.8%

Value	Count	Frequency (%)
1.04	1	< 0.1%
1.06	2	< 0.1%
1.07	6	0.1%
1.08	1	< 0.1%
1.09	4	0.1%
1.1	3	< 0.1%
1.11	5	0.1%
1.12	3	< 0.1%
1.13	4	0.1%
1.14	5	0.1%

Value	Count	Frequency (%)
195.59	1	< 0.1%
195.533	1	< 0.1%
195.371	1	< 0.1%
195.25	1	< 0.1%
195.24	1	< 0.1%
195.23	1	< 0.1%
194.97	1	< 0.1%
194.67	1	< 0.1%
194.6	1	< 0.1%
194.42	1	< 0.1%

Order Priority
Categorical

Distinct	4
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	469.9 KiB

Medium	3423
High	2894
Critical	939
Low	463

Length

Max length	8
Median length	6
Mean length	5.3135121
Min length	3

Characters and Unicode

Total characters	41015
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	High
2nd row	High
3rd row	High
4th row	High
5th row	Low

Common Values

Value	Count	Frequency (%)
Medium	3423	44.3%
High	2894	37.5%
Critical	939	12.2%
Low	463	6.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
medium	3423	44.3%
high	2894	37.5%
critical	939	12.2%
low	463	6.0%

Most occurring characters

Value	Count	Frequency (%)
i	8195	20.0%
M	3423	8.3%
d	3423	8.3%
u	3423	8.3%
m	3423	8.3%
e	3423	8.3%
H	2894	7.1%
g	2894	7.1%
h	2894	7.1%
c	939	2.3%
Other values (8)	6084	14.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	41015	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	8195	20.0%
M	3423	8.3%
d	3423	8.3%
u	3423	8.3%
m	3423	8.3%
e	3423	8.3%
H	2894	7.1%
g	2894	7.1%
h	2894	7.1%
c	939	2.3%
Other values (8)	6084	14.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	41015	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	8195	20.0%
M	3423	8.3%
d	3423	8.3%
u	3423	8.3%
m	3423	8.3%
e	3423	8.3%
H	2894	7.1%
g	2894	7.1%
h	2894	7.1%
c	939	2.3%
Other values (8)	6084	14.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	41015	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	8195	20.0%
M	3423	8.3%
d	3423	8.3%
u	3423	8.3%
m	3423	8.3%
e	3423	8.3%
H	2894	7.1%
g	2894	7.1%
h	2894	7.1%
c	939	2.3%
Other values (8)	6084	14.8%

Interactions

Correlations

	Category	Discount	E-Commerce Site	Market	Order Priority	Profit	Quantity	Region	Row ID	Sales	Segment	Ship Mode	Shipping Cost	Sub-Category
Category	1.000	0.236	0.000	0.243	0.043	0.181	0.055	0.244	0.085	0.280	0.022	0.031	0.255	0.999
Discount	0.236	1.000	0.000	0.336	0.044	-0.397	0.022	0.395	-0.020	-0.025	0.012	0.035	-0.044	0.214
E-Commerce Site	0.000	0.000	1.000	0.020	0.000	0.024	0.000	0.000	0.024	0.000	0.004	0.000	0.024	0.000
Market	0.243	0.336	0.020	1.000	0.081	0.249	0.161	0.999	0.153	0.350	0.011	0.066	0.433	0.293
Order Priority	0.043	0.044	0.000	0.081	1.000	0.102	0.040	0.089	0.084	0.192	0.020	0.296	0.122	0.076
Profit	0.181	-0.397	0.024	0.249	0.102	1.000	0.129	0.181	-0.112	0.489	0.000	0.077	0.387	0.141
Quantity	0.055	0.022	0.000	0.161	0.040	0.129	1.000	0.144	-0.068	0.248	0.000	0.038	0.182	0.082
Region	0.244	0.395	0.000	0.999	0.089	0.181	0.144	1.000	0.108	0.235	0.025	0.078	0.289	0.153
Row ID	0.085	-0.020	0.024	0.153	0.084	-0.112	-0.068	0.108	1.000	-0.284	0.030	0.073	-0.568	0.073
Sales	0.280	-0.025	0.000	0.350	0.192	0.489	0.248	0.235	-0.284	1.000	0.000	0.159	0.727	0.223
Segment	0.022	0.012	0.004	0.011	0.020	0.000	0.000	0.025	0.030	0.000	1.000	0.011	0.020	0.019
Ship Mode	0.031	0.035	0.000	0.066	0.296	0.077	0.038	0.078	0.073	0.159	0.011	1.000	0.098	0.065
Shipping Cost	0.255	-0.044	0.024	0.433	0.122	0.387	0.182	0.289	-0.568	0.727	0.020	0.098	1.000	0.204
Sub-Category	0.999	0.214	0.000	0.293	0.076	0.141	0.082	0.153	0.073	0.223	0.019	0.065	0.204	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

	Row ID	Order ID	Order Date	Ship Date	Ship Mode	Customer ID	Customer Name	Segment	City	State	Country	Region	Market	Product ID	E-Commerce Site	Category	Sub-Category	Product Name	Sales	Quantity	Discount	Profit	Shipping Cost	Order Priority
0	1	CA-2014-AB10015140-41954	2014-11-11	2014-11-13	First Class	AB-100151402	Aaron Bergman	Consumer	Oklahoma City	Oklahoma	United States	Central US	USCA	TEC-PH-5816	Snapdeal	Technology	Phones	Samsung Convoy 3	221.980	2	0.0	62.1544	40.77	High
1	9	CA-2014-AB10015140-41954	2014-11-11	2014-11-13	First Class	AB-100151402	Aaron Bergman	Consumer	Oklahoma City	Oklahoma	United States	Central US	USCA	FUR-BO-5957	Snapdeal	Furniture	Bookcases	Sauder Facets Collection Library, Sky Alder Finish	341.960	2	0.0	54.7136	25.27	High
2	10	CA-2012-AB10015140-40974	2012-03-06	2012-03-07	First Class	AB-100151404	Aaron Bergman	Consumer	Seattle	Washington	United States	Western US	USCA	FUR-CH-4421	Snapdeal	Furniture	Chairs	Global Push Button Manager's Chair, Indigo	48.712	1	0.2	5.4801	11.13	High
3	11	CA-2012-AB10015140-40974	2012-03-06	2012-03-07	First Class	AB-100151404	Aaron Bergman	Consumer	Seattle	Washington	United States	Western US	USCA	OFF-AR-5309	Flipkart	Office Supplies	Art	Newell 330	17.940	3	0.0	4.6644	4.29	High
4	17	CA-2012-AB10015140-40958	2012-02-19	2012-02-25	Standard Class	AB-100151402	Aaron Bergman	Consumer	Arlington	Texas	United States	Central US	USCA	OFF-ST-3078	Amazon	Office Supplies	Storage	Akro Stacking Bins	12.624	2	0.2	-2.5248	1.97	Low
5	22	CA-2012-AB10015140-40974	2012-03-06	2012-03-07	First Class	AB-100151404	Aaron Bergman	Consumer	Seattle	Washington	United States	Western US	USCA	OFF-ST-3744	Amazon	Office Supplies	Storage	Carina 42"Hx23 3/4"W Media Storage Unit	242.940	3	0.0	4.8588	1.28	High
6	29	CA-2012-AH10030140-41020	2012-04-21	2012-04-23	Second Class	AH-100301406	Aaron Hawkins	Corporate	Troy	New York	United States	Eastern US	USCA	OFF-FA-6129	Flipkart	Office Supplies	Fasteners	Staples	247.840	8	0.0	121.4416	55.20	Critical
7	33	CA-2013-AH10030140-41635	2013-12-27	2013-12-31	Standard Class	AH-100301404	Aaron Hawkins	Corporate	San Francisco	California	United States	Western US	USCA	TEC-PH-4389	Amazon	Technology	Phones	Geemarc AmpliPOWER60	668.160	9	0.2	75.1680	45.74	Medium
8	35	CA-2013-AH10030140-41635	2013-12-27	2013-12-31	Standard Class	AH-100301404	Aaron Hawkins	Corporate	San Francisco	California	United States	Western US	USCA	OFF-ST-4291	Flipkart	Office Supplies	Storage	Fellowes Super Stor/Drawer Files	323.100	2	0.0	61.3890	26.70	Medium
9	37	CA-2012-AH10030140-41041	2012-05-12	2012-05-18	Standard Class	AH-100301404	Aaron Hawkins	Corporate	Los Angeles	California	United States	Western US	USCA	FUR-CH-4840	Amazon	Furniture	Chairs	Iceberg Nesting Folding Chair, 19w x 6d x 43h	279.456	6	0.2	20.9592	11.69	Medium

	Row ID	Order ID	Order Date	Ship Date	Ship Mode	Customer ID	Customer Name	Segment	City	State	Country	Region	Market	Product ID	E-Commerce Site	Category	Sub-Category	Product Name	Sales	Quantity	Discount	Profit	Shipping Cost	Order Priority
7709	9989	IN-2015-JS158807-42180	2015-06-25	2015-06-30	Standard Class	JS-158807	John Stevenson	Consumer	Brisbane	Queensland	Australia	Oceania	Asia Pacific	OFF-ST-5702	Snapdeal	Office Supplies	Storage	Rogers Lockers, Single Width	571.455	3	0.1	215.865	32.950	Medium
7710	9990	IN-2012-VP217307-41166	2012-09-14	2012-09-17	Second Class	VP-217307	Victor Preis	Home Office	Brisbane	Queensland	Australia	Oceania	Asia Pacific	TEC-AC-4155	Snapdeal	Technology	Accessories	Enermax Keyboard, Bluetooth	75.114	1	0.1	-5.856	32.940	Critical
7711	9991	MX-2013-JF1519026-41305	2013-01-31	2013-02-05	Standard Class	JF-1519026	Jamie Frazer	Consumer	Santiago	Santiago	Chile	South America	LATAM	TEC-PH-5339	Amazon	Technology	Phones	Nokia Headset, Cordless	151.920	3	0.0	71.400	32.938	High
7712	9992	CA-2012-CK12205140-41075	2012-06-15	2012-06-20	Standard Class	CK-122051406	Chloris Kastensmidt	Consumer	Hempstead	New York	United States	Eastern US	USCA	OFF-AR-3517	Flipkart	Office Supplies	Art	Boston 16750 Black Compact Battery Pencil Sharpener	35.000	4	0.0	10.500	1.720	Medium
7713	9994	ES-2014-HA1490564-41863	2014-08-12	2014-08-16	Standard Class	HA-1490564	Helen Abelman	Consumer	Genoa	Liguria	Italy	Southern Europe	Europe	FUR-BO-5768	Flipkart	Furniture	Bookcases	Safco Corner Shelving, Metal	297.840	2	0.0	74.460	32.920	Medium
7714	9995	MX-2012-MS1777036-41193	2012-10-11	2012-10-16	Standard Class	MS-1777036	Maxwell Schwartz	Consumer	Santo Domingo	Santo Domingo	Dominican Republic	Caribbean	LATAM	OFF-AP-3584	Amazon	Office Supplies	Appliances	Breville Toaster, Silver	206.560	5	0.2	48.960	32.902	High
7715	9996	IN-2015-AS1013558-42229	2015-08-13	2015-08-18	Standard Class	AS-1013558	Adrian Shami	Home Office	Bilaspur	Uttar Pradesh	India	Southern Asia	Asia Pacific	TEC-AC-4165	Amazon	Technology	Accessories	Enermax Memory Card, Programmable	579.450	5	0.0	225.900	32.900	Medium
7716	9997	RS-2015-NH8610108-42364	2015-12-26	2015-12-28	Second Class	NH-8610108	Nicole Hansen	Corporate	Yaroslavl'	Yaroslavl'	Russia	Eastern Europe	Europe	TEC-CO-4576	Amazon	Technology	Copiers	Hewlett Fax Machine, Digital	319.560	1	0.0	146.970	32.900	Medium
7717	9998	IN-2012-CA1277558-41214	2012-11-01	2012-11-06	Standard Class	CA-1277558	Cynthia Arntzen	Consumer	Satna	Madhya Pradesh	India	Southern Asia	Asia Pacific	TEC-CO-5994	Amazon	Technology	Copiers	Sharp Fax and Copier, Digital	504.720	3	0.0	232.110	32.890	Medium
7718	9999	ES-2013-MC1813045-41597	2013-11-19	2013-11-24	Standard Class	MC-1813045	Mike Caudle	Corporate	Argenteuil	Ile-de-France	France	Western Europe	Europe	OFF-AR-3555	Snapdeal	Office Supplies	Art	Boston Sketch Pad, Water Color	414.240	8	0.0	12.240	32.890	Medium

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories